Michigan PFAS Dashboard
  • Project Overview
  • PFAS Concentrations
  • Hazard Analysis
  • About

Michigan PFAS Data

Data summary
Name pfas_sites
Number of rows 300
Number of columns 20
_______________________
Column type frequency:
character 16
numeric 4
________________________
Group variables None

Variable type: character

skim_variable n_missing complete_rate min max empty n_unique whitespace
facility 0 1.00 9 103 0 300 0
county 0 1.00 10 26 0 76 0
address 1 1.00 4 88 0 299 0
city 1 1.00 4 29 0 174 0
type 0 1.00 7 22 0 15 0
residential_wells_sampled 0 1.00 2 3 0 4 0
site_lead 0 1.00 9 65 0 107 0
site_lead_email 0 1.00 15 27 0 128 0
site_lead_phone 0 1.00 12 16 0 105 0
hyperlink 0 1.00 84 134 0 293 0
location 115 0.62 4 25 0 128 0
military 0 1.00 2 4 0 3 0
facility_date 8 0.97 22 22 0 190 0
site_background 265 0.12 626 3752 0 35 0
drinking_water_information 265 0.12 95 2098 0 35 0
anticipated_activities 265 0.12 15 397 0 35 0

Variable type: numeric

skim_variable n_missing complete_rate mean sd p0 p25 p50 p75 p100 hist
geoid 0 1 26088.58 45.84 26001.00 26049.00 26081.00 26125.00 26163.00 ▃▅▇▆▆
longitude 0 1 -84.82 1.32 -90.13 -85.70 -84.76 -83.66 -82.44 ▁▁▇▅▇
latitude 0 1 43.24 1.12 41.78 42.48 42.95 43.54 47.46 ▇▆▂▁▁
zip_code 0 1 49003.64 3935.16 20020.00 48453.50 48911.00 49442.25 94105.00 ▁▇▁▁▁
Data summary
Name surface_water_long
Number of rows 208548
Number of columns 26
_______________________
Column type frequency:
character 20
numeric 6
________________________
Group variables None

Variable type: character

skim_variable n_missing complete_rate min max empty n_unique whitespace
geoid 3024 0.99 5 5 0 70 0
lab_sample_id 108 1.00 6 12 0 1797 0
site_code 0 1.00 9 13 0 1349 0
coc_sample_id 7344 0.96 1 26 0 1537 0
sample_type 186624 0.11 6 16 0 5 0
lab_name 0 1.00 4 25 0 17 0
lab_job_name 16308 0.92 7 12 0 166 0
collection_date 0 1.00 22 22 0 198 0
analysis_method 108 1.00 4 29 0 10 0
analysis_date 25596 0.88 22 22 0 216 0
watershed 0 1.00 4 21 0 52 0
waterbody 108 1.00 5 31 0 589 0
location_code 0 1.00 6 10 0 1205 0
huc10 21708 0.90 9 10 0 153 0
huc8 0 1.00 8 8 0 55 0
project 0 1.00 4 13 0 2 0
description 216 1.00 2 53 0 1241 0
additional_description 121824 0.42 5 69 0 413 0
sample_depth 206712 0.01 6 10 0 3 0
analyte 0 1.00 14 25 0 108 0

Variable type: numeric

skim_variable n_missing complete_rate mean sd p0 p25 p50 p75 p100 hist
longitude 0 1.00 -84.86 1.75 -90.18 -85.85 -84.46 -83.54 -82.43 ▁▂▃▅▇
latitude 0 1.00 43.60 1.57 41.76 42.47 43.02 44.42 47.47 ▇▆▁▂▂
dilution_factor 16416 0.92 1.32 3.36 0.00 1.00 1.00 1.00 100.00 ▇▁▁▁▁
duplicate 0 1.00 1.11 0.34 1.00 1.00 1.00 1.00 3.00 ▇▁▁▁▁
visit_id 24516 0.88 2019889.60 1729.85 2013001.00 2019005.00 2020206.00 2021213.00 2022021.00 ▁▁▃▇▇
analyte_value 53414 0.74 3.42 59.55 0.10 0.81 1.17 2.00 11000.00 ▇▁▁▁▁
Data summary
Name public_water_wide
Number of rows 16109
Number of columns 50
_______________________
Column type frequency:
character 16
logical 10
numeric 24
________________________
Group variables None

Variable type: character

skim_variable n_missing complete_rate min max empty n_unique whitespace
geoid 824 0.95 5 5 0 87 0
system_name 274 0.98 3 59 0 4727 0
system_type 0 1.00 3 7 0 12 0
loc_name 4691 0.71 1 31 0 274 0
sys_loc_code 10695 0.34 12 20 0 3408 0
position_source 4 1.00 4 4 0 2 0
phase_code 10695 0.34 7 15 0 7 0
task_code 0 1.00 6 12 0 21 0
task_type 0 1.00 8 9 0 2 0
sample_date 0 1.00 22 22 0 3623 0
treatment_status 10769 0.33 2 7 0 6 0
sys_sample_code 0 1.00 5 20 0 15928 0
lab_name_code 0 1.00 3 40 0 43 0
lab_number 5414 0.66 4 4 0 28 0
lab_sdg 10695 0.34 6 8 0 4110 0
analytical_method 0 1.00 7 9 0 3 0

Variable type: logical

skim_variable n_missing complete_rate mean count
FTSA42Result 16109 0 NaN :
FTSA62Result 16109 0 NaN :
FTSA82Result 16109 0 NaN :
FOSAResult 16109 0 NaN :
PFBAResult 16109 0 NaN :
PFDSResult 16109 0 NaN :
PFHpSResult 16109 0 NaN :
PFNSResult 16109 0 NaN :
PFPeAResult 16109 0 NaN :
PFPeSResult 16109 0 NaN :

Variable type: numeric

skim_variable n_missing complete_rate mean sd p0 p25 p50 p75 p100 hist
longitude 0 1.00 -84.87 1.26 -90.17 -85.67 -84.88 -83.78 -82.38 ▁▁▆▇▆
latitude 0 1.00 43.37 1.24 41.72 42.48 42.96 44.05 47.47 ▇▅▂▂▁
object_id 0 1.00 8055.00 4650.41 1.00 4028.00 8055.00 12082.00 16109.00 ▇▇▇▇▇
hex_id 0 1.00 805.05 474.76 1.00 381.00 813.00 1222.00 1610.00 ▇▇▇▇▇
wssn 3 1.00 1058800.42 3078921.71 0.00 4090.00 40333.00 2022013.00 55293901.00 ▇▁▁▁▁
sampling_results_count 0 1.00 22.35 22.14 1.00 8.00 16.00 27.00 130.00 ▇▂▁▁▁
HFPODAResult 10686 0.34 0.06 2.20 0.00 0.00 0.00 0.00 100.00 ▇▁▁▁▁
PFBSResult 9883 0.39 1.75 7.42 0.00 0.00 0.00 0.00 230.00 ▇▁▁▁▁
PFHxAResult 10134 0.37 1.20 4.75 0.00 0.00 0.00 0.00 111.00 ▇▁▁▁▁
PFHxSResult 10226 0.37 1.55 11.35 0.00 0.00 0.00 0.00 347.00 ▇▁▁▁▁
PFNAResult 10628 0.34 0.08 0.99 0.00 0.00 0.00 0.00 34.00 ▇▁▁▁▁
PFOAResult 10124 0.37 1.35 14.35 0.00 0.00 0.00 0.00 780.00 ▇▁▁▁▁
PFOSResult 10195 0.37 1.42 15.03 0.00 0.00 0.00 0.00 740.00 ▇▁▁▁▁
PF3OUdS11ClResult 10693 0.34 0.00 0.04 0.00 0.00 0.00 0.00 3.00 ▇▁▁▁▁
PF3ONS9ClResult 10693 0.34 0.00 0.03 0.00 0.00 0.00 0.00 2.00 ▇▁▁▁▁
ADONAResult 10694 0.34 0.00 0.01 0.00 0.00 0.00 0.00 1.00 ▇▁▁▁▁
NEtFOSAAResult 10652 0.34 0.11 2.71 0.00 0.00 0.00 0.00 110.00 ▇▁▁▁▁
NMeFOSAAResult 10661 0.34 0.31 14.23 0.00 0.00 0.00 0.00 860.00 ▇▁▁▁▁
PFDAResult 10680 0.34 0.06 2.18 0.00 0.00 0.00 0.00 93.00 ▇▁▁▁▁
PFDoDAResult 10692 0.34 0.00 0.10 0.00 0.00 0.00 0.00 6.00 ▇▁▁▁▁
PFHpAResult 10491 0.35 0.40 2.94 0.00 0.00 0.00 0.00 150.00 ▇▁▁▁▁
PFTeDAResult 10693 0.34 0.00 0.06 0.00 0.00 0.00 0.00 4.00 ▇▁▁▁▁
PFTrDAResult 10679 0.34 0.01 0.25 0.00 0.00 0.00 0.00 8.00 ▇▁▁▁▁
PFUnDAResult 10679 0.34 0.07 1.56 0.00 0.00 0.00 0.00 63.00 ▇▁▁▁▁
Rows: 16,109
Columns: 50
$ geoid                  <chr> "26139", "26139", "26139", "26139", "26139", "2…
$ longitude              <dbl> -85.82290, -85.82290, -85.82290, -85.82290, -85…
$ latitude               <dbl> 43.04939, 43.04939, 43.04939, 43.04939, 43.0493…
$ object_id              <dbl> 1, 1367, 1368, 8100, 8101, 8102, 8103, 12398, 1…
$ hex_id                 <dbl> 1407, 1407, 1407, 1407, 1407, 1407, 1407, 1407,…
$ system_name            <chr> "1239 Comstock LLC.", "Dewys Manufacturing", "D…
$ wssn                   <dbl> 2043570, 2048770, 2054870, 2048770, 2048770, 20…
$ system_type            <chr> "INDUS", "INDUS", "INDUS", "MUN", "MUN", "MUN",…
$ loc_name               <chr> "LOC01", "LOC01", "LOC02", NA, NA, NA, NA, NA, …
$ sys_loc_code           <chr> "INDUS-023-LOC01", "INDUS-089-LOC01", "INDUS-08…
$ position_source        <chr> "EGLE", "EGLE", "YUMA", "EGLE", "EGLE", "EGLE",…
$ phase_code             <chr> "PHASE_2", "PHASE_2", "PHASE_2", NA, NA, NA, NA…
$ task_code              <chr> "PHASE_2", "PHASE_2", "PHASE_2", "ComplMon", "C…
$ task_type              <chr> "StateSurv", "StateSurv", "StateSurv", "ComplMo…
$ sample_date            <chr> "2019/05/17 00:00:00+00", "2019/05/17 00:00:00+…
$ treatment_status       <chr> "Treated", "Raw", "Raw", NA, NA, NA, NA, NA, NA…
$ sys_sample_code        <chr> "GWEF1905170855RL", "GWNT1905170930RL", "GWNT19…
$ lab_name_code          <chr> "VAL", "VAL", "VAL", "Prein-Newhof", "Prein-New…
$ lab_number             <chr> NA, NA, NA, "0020", "0020", "0020", "0020", "00…
$ lab_sdg                <chr> "1901207", "1901207", "1901207", NA, NA, NA, NA…
$ analytical_method      <chr> "EPA-537", "EPA-537", "EPA-537", "EPA 537.1", "…
$ sampling_results_count <dbl> 17, 17, 17, 17, 17, 17, 17, 17, 17, 17, 17, 17,…
$ HFPODAResult           <dbl> 0, 0, 0, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA…
$ PFBSResult             <dbl> 0, 0, 0, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA…
$ PFHxAResult            <dbl> 0, 0, 0, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA…
$ PFHxSResult            <dbl> 0, 0, 0, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA…
$ PFNAResult             <dbl> 0, 0, 0, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA…
$ PFOAResult             <dbl> 0, 0, 0, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA…
$ PFOSResult             <dbl> 0, 0, 0, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA…
$ PF3OUdS11ClResult      <dbl> 0, 0, 0, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA…
$ PF3ONS9ClResult        <dbl> 0, 0, 0, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA…
$ ADONAResult            <dbl> 0, 0, 0, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA…
$ FTSA42Result           <lgl> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA,…
$ FTSA62Result           <lgl> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA,…
$ FTSA82Result           <lgl> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA,…
$ FOSAResult             <lgl> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA,…
$ NEtFOSAAResult         <dbl> 0, 0, 0, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA…
$ NMeFOSAAResult         <dbl> 0, 0, 0, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA…
$ PFBAResult             <lgl> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA,…
$ PFDAResult             <dbl> 0, 0, 0, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA…
$ PFDoDAResult           <dbl> 0, 0, 0, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA…
$ PFDSResult             <lgl> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA,…
$ PFHpAResult            <dbl> 0, 0, 0, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA…
$ PFHpSResult            <lgl> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA,…
$ PFNSResult             <lgl> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA,…
$ PFPeAResult            <lgl> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA,…
$ PFPeSResult            <lgl> NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA,…
$ PFTeDAResult           <dbl> 0, 0, 0, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA…
$ PFTrDAResult           <dbl> 0, 0, 0, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA…
$ PFUnDAResult           <dbl> 0, 0, 0, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA…

# A tibble: 5 × 51
  geoid longitude latitude object_id hex_id system_name         wssn system_type
  <chr>     <dbl>    <dbl>     <dbl>  <dbl> <chr>              <dbl> <chr>      
1 26139     -85.8     43.0         1   1407 1239 Comstock LL… 2.04e6 INDUS      
2 26139     -85.8     43.0      1367   1407 Dewys Manufactur… 2.05e6 INDUS      
3 26139     -85.8     43.0      1368   1407 Dewys Manufactur… 2.05e6 INDUS      
4 26139     -85.8     43.0      8100   1407 DEWYS MANUFACTUR… 2.05e6 MUN        
5 26139     -85.8     43.0      8101   1407 DEWYS MANUFACTUR… 2.05e6 MUN        
# ℹ 43 more variables: loc_name <chr>, sys_loc_code <chr>,
#   position_source <chr>, phase_code <chr>, task_code <chr>, task_type <chr>,
#   sample_date <chr>, treatment_status <chr>, sys_sample_code <chr>,
#   lab_name_code <chr>, lab_number <chr>, lab_sdg <chr>,
#   analytical_method <chr>, sampling_results_count <dbl>, HFPODAResult <dbl>,
#   PFBSResult <dbl>, PFHxAResult <dbl>, PFHxSResult <dbl>, PFNAResult <dbl>,
#   PFOAResult <dbl>, PFOSResult <dbl>, PF3OUdS11ClResult <dbl>, …

hex_id

Hazard_Index

HFPODAResult

PFNAResult

PFBSResult

PFHxSResult

234

34.72050

0

0

41.0

347

234

31.33150

0

0

63.0

313

234

31.01750

0

0

35.0

310

234

30.11750

0

0

35.0

301

234

27.01300

0

0

26.0

270

234

24.81200

0

0

24.0

248

234

22.51550

0

0

31.0

225

234

22.21250

0

0

25.0

222

394

10.00000

100

0

0.0

0

553

9.30000

93

0

0.0

0

1,114

8.70000

87

0

0.0

0

5

6.71500

0

0

30.0

67

37

6.20300

0

0

6.0

62

37

5.80250

0

0

5.0

58

5

5.11100

0

0

22.0

51

1,177

5.10000

0

0

0.0

51

5

4.91350

0

0

27.0

49

37

4.90250

0

0

5.0

49

37

4.90250

0

0

5.0

49

1,562

4.80600

0

8

12.0

40

1,177

4.80000

0

0

0.0

48

5

4.61150

0

0

23.0

46

766

4.50100

0

34

2.0

11

1,177

4.30000

0

0

0.0

43

766

4.20000

0

32

0.0

10

1,177

4.10000

0

0

0.0

41

1,177

4.00000

0

0

0.0

40

250

4.00000

0

0

0.0

40

124

3.90150

0

0

3.0

39

124

3.80200

0

0

4.0

38

1,177

3.70000

0

0

0.0

37

1,440

3.60400

0

0

8.0

36

1,152

3.60300

0

0

6.0

36

1,152

3.60220

0

0

4.4

36

124

3.60150

0

0

3.0

36

124

3.60150

0

0

3.0

36

124

3.60150

0

0

3.0

36

124

3.60150

0

0

3.0

36

1,152

3.50250

0

0

5.0

35

37

3.50200

0

0

4.0

35

37

3.50200

0

0

4.0

35

124

3.50150

0

0

3.0

35

124

3.50150

0

0

3.0

35

124

3.40150

0

0

3.0

34

1,177

3.40000

0

0

0.0

34

124

3.30150

0

0

3.0

33

5

3.21950

0

0

39.0

32

419

3.20350

0

0

7.0

32

1,152

3.20250

0

0

5.0

32

1,275

3.20190

0

0

3.8

32

1,275

3.20190

0

0

3.8

32

124

3.20150

0

0

3.0

32

124

3.20150

0

0

3.0

32

766

3.20100

0

20

2.0

12

1,177

3.20000

0

0

0.0

32

419

3.10350

0

0

7.0

31

1,440

3.10300

0

0

6.0

31

1,440

3.00300

0

0

6.0

30

1,440

3.00300

0

0

6.0

30

1,440

3.00250

0

0

5.0

30

1,152

3.00250

0

0

5.0

30

1,177

3.00000

0

0

0.0

30

1,177

3.00000

0

0

0.0

30

1,177

3.00000

0

0

0.0

30

766

3.00000

0

19

0.0

11

1,152

2.90200

0

0

4.0

29

37

2.90150

0

0

3.0

29

37

2.90150

0

0

3.0

29

124

2.90150

0

0

3.0

29

766

2.90100

0

17

2.0

12

1,152

2.80300

0

0

6.0

28

1,152

2.80200

0

0

4.0

28

124

2.80150

0

0

3.0

28

124

2.80150

0

0

3.0

28

766

2.80000

0

18

0.0

10

5

2.71650

0

0

33.0

27

5

2.70750

0

0

15.0

27

5

2.70150

0

0

3.0

27

766

2.70150

0

0

3.0

27

1,440

2.60300

0

0

6.0

26

124

2.60150

0

0

3.0

26

124

2.60150

0

0

3.0

26

124

2.60150

0

0

3.0

26

1,562

2.50350

0

6

7.0

19

1,152

2.40250

0

0

5.0

24

5

2.40250

0

0

5.0

24

766

2.40100

0

8

2.0

16

1,177

2.40000

0

0

0.0

24

5

2.31450

0

0

29.0

23

296

2.30000

0

0

0.0

23

37

2.20250

0

0

5.0

22

1,377

2.20000

0

0

0.0

22

296

2.20000

0

0

0.0

22

293

2.20000

0

0

0.0

22

205

2.10250

0

0

5.0

21

37

2.10100

0

0

2.0

21

205

2.10100

0

0

2.0

21

766

2.10000

0

0

0.0

21

296

2.10000

0

0

0.0

21

5

2.00700

0

0

14.0

20

419

2.00250

0

0

5.0

20

205

2.00000

0

0

0.0

20

296

2.00000

0

0

0.0

20

299

1.91450

0

0

29.0

19

37

1.90200

0

0

4.0

19

296

1.90150

0

0

3.0

19

1,521

1.90115

0

0

2.3

19

250

1.90000

0

0

0.0

19

296

1.90000

0

0

0.0

19

205

1.80300

0

0

6.0

18

205

1.80250

0

0

5.0

18

296

1.80250

0

0

5.0

18

1,003

1.80200

0

0

4.0

18

419

1.80200

0

0

4.0

18

419

1.80200

0

0

4.0

18

124

1.80150

0

0

3.0

18

37

1.80100

0

0

2.0

18

1,521

1.80000

0

0

0.0

18

1,348

1.80000

0

0

0.0

18

205

1.80000

0

0

0.0

18

205

1.80000

0

0

0.0

18

296

1.80000

0

0

0.0

18

296

1.80000

0

0

0.0

18

1,562

1.70400

0

0

8.0

17

5

1.70250

0

0

5.0

17

1,263

1.70200

0

0

4.0

17

37

1.70150

0

0

3.0

17

296

1.70150

0

0

3.0

17

296

1.70150

0

0

3.0

17

205

1.70100

0

0

2.0

17

766

1.70100

0

3

2.0

14

766

1.70000

0

6

0.0

11

1,348

1.70000

0

0

0.0

17

766

1.70000

0

7

0.0

10

1,440

1.60250

0

0

5.0

16

419

1.60200

0

0

4.0

16

124

1.60100

0

0

2.0

16

1,177

1.60000

0

0

0.0

16

1,177

1.60000

0

0

0.0

16

1,177

1.60000

0

0

0.0

16

766

1.60000

0

8

0.0

8

293

1.60000

0

0

0.0

16

360

1.50200

0

0

4.0

15

37

1.50150

0

0

3.0

15

124

1.50150

0

0

3.0

15

766

1.50150

0

5

3.0

10

37

1.50100

0

0

2.0

15

766

1.50100

0

0

2.0

15

766

1.50100

0

0

2.0

15

766

1.50100

0

0

2.0

15

766

1.50100

0

3

2.0

12

296

1.50100

0

0

2.0

15

296

1.50100

0

0

2.0

15

296

1.50100

0

0

2.0

15

37

1.50000

0

0

0.0

15

5

1.41000

0

0

20.0

14

360

1.40250

0

0

5.0

14

360

1.40250

0

0

5.0

14

360

1.40200

0

0

4.0

14

1,076

1.40150

0

14

3.0

0

1,304

1.40150

0

0

3.0

14

296

1.40150

0

0

3.0

14

1,377

1.40100

0

0

2.0

14

419

1.40100

0

0

2.0

14

124

1.40100

0

0

2.0

14

171

1.40100

0

0

2.0

14

124

1.40000

0

0

0.0

14

293

1.40000

0

0

0.0

14

293

1.40000

0

0

0.0

14

360

1.30200

0

0

4.0

13

1,263

1.30150

0

0

3.0

13

124

1.30100

0

0

2.0

13

1,386

1.20950

0

0

19.0

12

1,386

1.20950

0

0

19.0

12

515

1.20300

0

0

6.0

12

515

1.20250

0

0

5.0

12

205

1.20250

0

0

5.0

12

205

1.20150

0

0

3.0

12

124

1.20100

0

0

2.0

12

296

1.20100

0

0

2.0

12

1,377

1.20000

0

0

0.0

12

1,177

1.20000

0

0

0.0

12

1,492

1.20000

0

0

0.0

12

1,386

1.11050

0

0

21.0

11

1,386

1.11050

0

0

21.0

11

299

1.10900

0

0

18.0

11

1,386

1.10900

0

0

18.0

11

5

1.10850

0

0

17.0

11

5

1.10850

0

0

17.0

11

1,304

1.10100

0

0

2.0

11

296

1.10100

0

0

2.0

11

1,521

1.10000

0

0

0.0

11

1,377

1.10000

0

0

0.0

11

1,377

1.10000

0

0

0.0

11

1,177

1.10000

0

0

0.0

11

1,177

1.10000

0

0

0.0

11

78

1.10000

0

0

0.0

11

766

1.10000

0

0

0.0

11

171

1.10000

0

0

0.0

11

293

1.10000

0

0

0.0

11

299

1.00950

0

0

19.0

10

1,386

1.00950

0

0

19.0

10

5

1.00750

0

0

15.0

10

5

1.00700

0

0

14.0

10

5

1.00700

0

0

14.0

10

5

1.00700

0

0

14.0

10

296

1.00650

0

0

13.0

10

374

1.00450

0

0

9.0

10

515

1.00150

0

0

3.0

10

431

1.00150

0

0

3.0

10

# A tibble: 5 × 51
  geoid longitude latitude object_id hex_id system_name         wssn system_type
  <chr>     <dbl>    <dbl>     <dbl>  <dbl> <chr>              <dbl> <chr>      
1 26129     -84.1     44.2      1090      1 Cole Canoe Base   2.00e6 CHLCMP     
2 26051     -84.4     44.1      2765      2 Lakeside Develop… 3.75e3 MUN        
3 26157     -83.5     43.7      5031      3 Usa Elementary S… 2.03e6 SCH        
4 26125     -83.2     42.6      1098      4 College Heights … 4.04e4 MUN        
5 26139     -86.1     43.0      4257      5 Robinson Element… 2.03e6 SCH        
# ℹ 43 more variables: loc_name <chr>, sys_loc_code <chr>,
#   position_source <chr>, phase_code <chr>, task_code <chr>, task_type <chr>,
#   sample_date <chr>, treatment_status <chr>, sys_sample_code <chr>,
#   lab_name_code <chr>, lab_number <chr>, lab_sdg <chr>,
#   analytical_method <chr>, sampling_results_count <dbl>, HFPODAResult <dbl>,
#   PFBSResult <dbl>, PFHxAResult <dbl>, PFHxSResult <dbl>, PFNAResult <dbl>,
#   PFOAResult <dbl>, PFOSResult <dbl>, PF3OUdS11ClResult <dbl>, …

hex_id

Hazard_Index

HFPODAResult

PFNAResult

PFBSResult

PFHxSResult

234

34.72050

0

0

41.0

347

394

10.00000

100

0

0.0

0

553

9.30000

93

0

0.0

0

1,114

8.70000

87

0

0.0

0

5

6.71500

0

0

30.0

67

37

6.20300

0

0

6.0

62

1,177

5.10000

0

0

0.0

51

1,562

4.80600

0

8

12.0

40

766

4.50100

0

34

2.0

11

250

4.00000

0

0

0.0

40

124

3.90150

0

0

3.0

39

1,440

3.60400

0

0

8.0

36

1,152

3.60300

0

0

6.0

36

419

3.20350

0

0

7.0

32

1,275

3.20190

0

0

3.8

32

296

2.30000

0

0

0.0

23

293

2.20000

0

0

0.0

22

1,377

2.20000

0

0

0.0

22

205

2.10250

0

0

5.0

21

299

1.91450

0

0

29.0

19

1,521

1.90115

0

0

2.3

19

1,003

1.80200

0

0

4.0

18

1,348

1.80000

0

0

0.0

18

1,263

1.70200

0

0

4.0

17

360

1.50200

0

0

4.0

15

1,076

1.40150

0

14

3.0

0

1,304

1.40150

0

0

3.0

14

171

1.40100

0

0

2.0

14

1,386

1.20950

0

0

19.0

12

515

1.20300

0

0

6.0

12

1,492

1.20000

0

0

0.0

12

78

1.10000

0

0

0.0

11

374

1.00450

0

0

9.0

10

431

1.00150

0

0

3.0

10

# A tibble: 5 × 25
  geoid longitude latitude object_id hex_id system_name        wssn system_type
  <chr>     <dbl>    <dbl>     <dbl>  <dbl> <chr>             <dbl> <chr>      
1 26129     -84.1     44.2      1090      1 Cole Canoe Base 2004765 CHLCMP     
2 26129     -84.1     44.2      1090      1 Cole Canoe Base 2004765 CHLCMP     
3 26129     -84.1     44.2      1090      1 Cole Canoe Base 2004765 CHLCMP     
4 26129     -84.1     44.2      1090      1 Cole Canoe Base 2004765 CHLCMP     
5 26129     -84.1     44.2      1090      1 Cole Canoe Base 2004765 CHLCMP     
# ℹ 17 more variables: loc_name <chr>, sys_loc_code <chr>,
#   position_source <chr>, phase_code <chr>, task_code <chr>, task_type <chr>,
#   sample_date <chr>, treatment_status <chr>, sys_sample_code <chr>,
#   lab_name_code <chr>, lab_number <chr>, lab_sdg <chr>,
#   analytical_method <chr>, sampling_results_count <dbl>, Hazard_Index <dbl>,
#   analyte <chr>, analyte_value <dbl>
Reading layer `cb_2018_us_county_500k' from data source 
  `/Users/nancyodhiambo/Library/CloudStorage/OneDrive-GrandValleyStateUniversity/Projects/Michigan_PFAS/Data cleaning, EDA & dashboard/pfas-dashboard/GeoFiles/cb_2018_us_county_500k.shp' 
  using driver `ESRI Shapefile'
Simple feature collection with 3233 features and 9 fields
Geometry type: MULTIPOLYGON
Dimension:     XY
Bounding box:  xmin: -179.1489 ymin: -14.5487 xmax: 179.7785 ymax: 71.36516
Geodetic CRS:  NAD83

System Type

Total Hazard

Number of Sites

Community Water Supply (for example Municipal Supply, Apartment, Nursing Home, Prison, etc.)

145.2770

985

School

22.6660

234

Non-Community Water Supply (Child Care Provider)

2.8275

80

Non-Community Water Supply (Children's Camp)

2.3135

110

Non-Community Water Supply (Industry)

1.8355

116

Office Building

1.4015

5

Non-Community Water Supply (Medical Care Provider)

0.7095

55

Non-Community Water Supply (Adult Foster Care Provider)

0.0000

6

Non-Community Water Supply (Hotel or Motel)

0.0000

4

Park

0.0000

2

Residential

0.0000

1

Tribal Lands

0.0000

12

Reading layer `cb_2018_us_county_500k' from data source 
  `/Users/nancyodhiambo/Library/CloudStorage/OneDrive-GrandValleyStateUniversity/Projects/Michigan_PFAS/Data cleaning, EDA & dashboard/pfas-dashboard/GeoFiles/cb_2018_us_county_500k.shp' 
  using driver `ESRI Shapefile'
Simple feature collection with 3233 features and 9 fields
Geometry type: MULTIPOLYGON
Dimension:     XY
Bounding box:  xmin: -179.1489 ymin: -14.5487 xmax: 179.7785 ymax: 71.36516
Geodetic CRS:  NAD83

Reading layer `cb_2018_us_county_500k' from data source 
  `/Users/nancyodhiambo/Library/CloudStorage/OneDrive-GrandValleyStateUniversity/Projects/Michigan_PFAS/Data cleaning, EDA & dashboard/pfas-dashboard/GeoFiles/cb_2018_us_county_500k.shp' 
  using driver `ESRI Shapefile'
Simple feature collection with 3233 features and 9 fields
Geometry type: MULTIPOLYGON
Dimension:     XY
Bounding box:  xmin: -179.1489 ymin: -14.5487 xmax: 179.7785 ymax: 71.36516
Geodetic CRS:  NAD83

Joining the two data sets (PFAS sites and public_water_max_long)

Reading layer `cb_2018_us_county_500k' from data source 
  `/Users/nancyodhiambo/Library/CloudStorage/OneDrive-GrandValleyStateUniversity/Projects/Michigan_PFAS/Data cleaning, EDA & dashboard/pfas-dashboard/GeoFiles/cb_2018_us_county_500k.shp' 
  using driver `ESRI Shapefile'
Simple feature collection with 3233 features and 9 fields
Geometry type: MULTIPOLYGON
Dimension:     XY
Bounding box:  xmin: -179.1489 ymin: -14.5487 xmax: 179.7785 ymax: 71.36516
Geodetic CRS:  NAD83

Reading layer `cb_2018_us_county_500k' from data source 
  `/Users/nancyodhiambo/Library/CloudStorage/OneDrive-GrandValleyStateUniversity/Projects/Michigan_PFAS/Data cleaning, EDA & dashboard/pfas-dashboard/GeoFiles/cb_2018_us_county_500k.shp' 
  using driver `ESRI Shapefile'
Simple feature collection with 3233 features and 9 fields
Geometry type: MULTIPOLYGON
Dimension:     XY
Bounding box:  xmin: -179.1489 ymin: -14.5487 xmax: 179.7785 ymax: 71.36516
Geodetic CRS:  NAD83

type

total_hazard

n_sites

HFPODA

PFBS

PFHxS

PFNA

Airport

371.4280

15

280

114.0

640

8

Landfill

264.6742

20

93

137.1

526

42

Fire Related

200.9636

12

187

81.8

307

8

Industrial

148.6296

11

0

114.8

363

8

Military

144.0460

9

187

23.0

139

34

Plating

111.6746

8

93

37.3

186

0

Wastewater

93.6640

8

0

32.0

234

0

Paper Manufacturing

76.1160

6

0

58.0

182

8

Unknown

41.6460

4

0

23.0

104

0

Tannery

28.8180

2

0

9.0

72

0

Laundromat/Dry Cleaner

22.0280

4

0

14.0

55

0

MIlitary

8.8000

1

0

0.0

22

0

Refinery

6.8080

1

0

4.0

17

0

 

© 2025 Nancy Odhiambo | Michigan PFAS Dashboard Project